UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WWrqY3kGR9xIbekiAFXDqGGXdRc0YWkhKeGnG14mclA='
WHERE
key_id = '6fca6fde498cb64b4a7166ca6e4c205b8500fd53db53781ac49781acccc7ea48'
AND (
token = 'WWrqY3kGR9xIbekiAFXDqGGXdRc0YWkhKeGnG14mclA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)