UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xnjdDuovMpTa2Y2CjqEs7CooLjWAh7OCXocO3CJQ4wU='
WHERE
key_id = 'a78bfe4767606992dc12bce482b3647cf24885bf588160ef5bb834303b2a7c14'
AND (
token = 'xnjdDuovMpTa2Y2CjqEs7CooLjWAh7OCXocO3CJQ4wU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)