UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H4BJM0ns8fOyg5uGuFHhiNflcnZKkI9GamuwMOvxeW8='
WHERE
key_id = '31b45c1789353ddb102bdc3ab9f64e1427f06d0444d77898b09d067a08e26523'
AND (
token = 'H4BJM0ns8fOyg5uGuFHhiNflcnZKkI9GamuwMOvxeW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)