UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NtKMyFe0rnBNhd2jHOVPq6tILXK+iXZyyvuUdd0HE9E='
WHERE
key_id = '518f49231a1527d80b46075654d84363ba722f6884e723dd4ff6eba3dcff12ce'
AND (
token = 'NtKMyFe0rnBNhd2jHOVPq6tILXK+iXZyyvuUdd0HE9E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)