UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ly6msRaN9h9Spbpi74o9sDxmkxK0FKBMxBHkG4zwr/w='
WHERE
key_id = 'a6c6aef143673e1358c69603fa98c5943e8a02a9ccefd57aca4773fa7a55d74f'
AND (
token = 'ly6msRaN9h9Spbpi74o9sDxmkxK0FKBMxBHkG4zwr/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)