UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HEzCd0loNin4EeKSsXXIzKkn+BjcBiBEkODNRZbnpvE='
WHERE
key_id = '9c0b5248eca1a7cc422a9fbc10a05f9d25cafb7fa1b1705d44d180cb00f8006d'
AND (
token = 'HEzCd0loNin4EeKSsXXIzKkn+BjcBiBEkODNRZbnpvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)