UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zl1nJhjaAaURsxnbXOS0xwczjWmb2jIo2cXT4oRKHEw='
WHERE
key_id = '35736592ed036b16d6b81db31191d2ed55fb8d7758175af7cd7a652d8355ce6e'
AND (
token = 'zl1nJhjaAaURsxnbXOS0xwczjWmb2jIo2cXT4oRKHEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)