UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PhAP7D7wczvV1LFQ1uHywBMbEWtkPjn0VaD/GbGjCt4='
WHERE
key_id = '7478aef24c833eadea49be1fc4f57180334519350dd82ddce24cf159b7594693'
AND (
token = 'PhAP7D7wczvV1LFQ1uHywBMbEWtkPjn0VaD/GbGjCt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)