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