UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F6ZFXqD8UpoJsiO/WUpjgTSVBUBN2dhnWGPgNQEufEs='
WHERE
key_id = 'd0768871924b6b7de7e9a9ed8c0ae06fa79710e5ef442032f6578f9b65e1231f'
AND (
token = 'F6ZFXqD8UpoJsiO/WUpjgTSVBUBN2dhnWGPgNQEufEs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)