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