UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W2R8YrhA5rxetmcdcgxMfXFZ6SjdkykhW9u963QlidY='
WHERE
key_id = '4978653a1b8f6faa4ea133566ea31a7edf18f16bde956f1510ff08e10080de9f'
AND (
token = 'W2R8YrhA5rxetmcdcgxMfXFZ6SjdkykhW9u963QlidY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)