UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N4E9MH2wnWecMptFvNMYvUJHk6QJ4jqK0tgrKUDwX7E='
WHERE
key_id = '0e0966808fa9c5e2085521c62186989883b753ed8a871c2e7e5c97c9d168077d'
AND (
token = 'N4E9MH2wnWecMptFvNMYvUJHk6QJ4jqK0tgrKUDwX7E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)