UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'B4H2BKdYKgdCmmdZlDTMp9CQiWoHCKO0uNgXyru4ekE=' 
WHERE 
  key_id = '54473abcb2a46183707fb8e65c1a9836f759866b28821b20a178938a4bc0de06' 
  AND (
    token = 'B4H2BKdYKgdCmmdZlDTMp9CQiWoHCKO0uNgXyru4ekE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026