UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8tHjGcvZV7FVrNnn9cQ7/ylmqDS/w69rELvoJcu1wCA='
WHERE
key_id = 'e7c6f4ecdcec5bba9395f8a821ee00adcadca6404b227921eddd2a9b67e13b60'
AND (
token = '8tHjGcvZV7FVrNnn9cQ7/ylmqDS/w69rELvoJcu1wCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)