UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U9waNTz4UHWErK5a81i0HwwJsGtbwKLXiRRBZFIaE9w='
WHERE
key_id = '1e015425680df0cee38f51a2f4d4f99c2aa316abb00f9af4d591213b9a2040e9'
AND (
token = 'U9waNTz4UHWErK5a81i0HwwJsGtbwKLXiRRBZFIaE9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)