UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j2tZ/iBKa0zitTlMcK4sX1/ntD6JVdIwnLvRHqIuvdw='
WHERE
key_id = 'd6b3a29b7fd5e58a96b77609924225d1f7e0172fd19f3b9a1df3009f013152ac'
AND (
token = 'j2tZ/iBKa0zitTlMcK4sX1/ntD6JVdIwnLvRHqIuvdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)