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