UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZbjvD4VnPI29/ZVX1HIKse/4Mr9lxGnUNiz35R+ZQAE=' 
WHERE 
  key_id = 'd0cc3239f41cead113b698f302db08e7cefd22eac5321ba8b553120cf04899c4' 
  AND (
    token = 'ZbjvD4VnPI29/ZVX1HIKse/4Mr9lxGnUNiz35R+ZQAE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047