UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Ps5f4mIUITEXQeMT3qB0T7wUgQBQQWFo4Md+Lfz/YCw=' 
WHERE 
  key_id = '2478af20478a1e5833513c9d7cdaf40d1c410ce41046f003af8b449098ff6abb' 
  AND (
    token = 'Ps5f4mIUITEXQeMT3qB0T7wUgQBQQWFo4Md+Lfz/YCw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00076