UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hzi1J4XSPY806B24EYgyEBjP7ZgEYsJp0rQvSnV9iR8='
WHERE
key_id = 'a66e9124d724a80eb4b88a2bf8b126bdfc5f35f84ea9d43989b6e592e9ba7412'
AND (
token = 'Hzi1J4XSPY806B24EYgyEBjP7ZgEYsJp0rQvSnV9iR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)