UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kK77ZN96m/kYE7SqZSxjPsvtn91BSNzbS0yBtaZJSro='
WHERE
key_id = 'eb4b536b83be4a3ee7c3fde939032e8941e282c14efa0d52ad34e3888d1fdec1'
AND (
token = 'kK77ZN96m/kYE7SqZSxjPsvtn91BSNzbS0yBtaZJSro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)