UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1SqQrbXZ3+x+3WarypQVjmbAJngIBIsrybsjE43PeYc='
WHERE
key_id = 'a65ec9f4c18046cc1b1b28c9d0e74ff40872af20477d3c14c68fcfee4ea2cf25'
AND (
token = '1SqQrbXZ3+x+3WarypQVjmbAJngIBIsrybsjE43PeYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)