UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gFNcENSrdKUpgwBeqwOhnbdtcjM6ZQqZHoF8V1xFsWE='
WHERE
key_id = '093a96d2f5e65c16cad2a1276f88cc257b72f0b64d0172605d2c7c00d90a97a4'
AND (
token = 'gFNcENSrdKUpgwBeqwOhnbdtcjM6ZQqZHoF8V1xFsWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)