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