UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q65IYejBM4nEtI0RPxUCQPcGXBexzvW7qR046aegtwM='
WHERE
key_id = '23fb03f014c5fef9b87a913427f2e4fd68dd6188f1794b8b5864136145ee0b25'
AND (
token = 'Q65IYejBM4nEtI0RPxUCQPcGXBexzvW7qR046aegtwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)