UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pk7/YzDRNBwl046Vy4I0UKVwvFtcU7ZnT+3uiVZ8KhY='
WHERE
key_id = '7c227e3211920138d60d8338ceba497ecb029862aa68d0f349200f23fa8ee806'
AND (
token = 'Pk7/YzDRNBwl046Vy4I0UKVwvFtcU7ZnT+3uiVZ8KhY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)