UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KpqcuFd5m8NHNA9p/2BNShh5kYE3afYJF6b9k6MBbU8='
WHERE
key_id = '1169d0de185c0afd8cc31d556c67bd209e28bd437764117c7d1421bb2f98f515'
AND (
token = 'KpqcuFd5m8NHNA9p/2BNShh5kYE3afYJF6b9k6MBbU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)