UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3/4vOayBn7vHzr7NVMZl8L/BwYRsQW6gPcBsiZgz2CU='
WHERE
key_id = 'a99e9da4a16b92f5041af8187fd52390ce784d6e52b6e762af23b6559156f690'
AND (
token = '3/4vOayBn7vHzr7NVMZl8L/BwYRsQW6gPcBsiZgz2CU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)