UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BovQfND3Tifa0zbMwuGsr4LHYJebmEShkRIpk3dI4go=' 
WHERE 
  key_id = 'ac5e167f72525314a69e27104aa54a4fd37be63c5ac693d525f903059942d075' 
  AND (
    token = 'BovQfND3Tifa0zbMwuGsr4LHYJebmEShkRIpk3dI4go=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032