UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'GMAW3amTOrpKu/U8Mh0zJdQzOZhMdu1xl8oxDn6aSi4=' 
WHERE 
  key_id = 'd84c1398d36ad947a4a080226c744bee4a98e6b5efdd23b7bbe83bba1ca7316e' 
  AND (
    token = 'GMAW3amTOrpKu/U8Mh0zJdQzOZhMdu1xl8oxDn6aSi4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033