UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sd9piRRX4QRiAprJP7HqKnsoYPnnAr1oFMbgG2j63jg=' 
WHERE 
  key_id = '5d49a1f54e0943c6a56ad16857c61b321ebfaa0cb948e8a5b06929d4c55a7791' 
  AND (
    token = 'sd9piRRX4QRiAprJP7HqKnsoYPnnAr1oFMbgG2j63jg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033