UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NDGdkqdMplNDYngQisjUmlZoxW+51YvfyCEnvM5BxCY=' 
WHERE 
  key_id = '9ddac62a7881d0472d8e0b00d78ec79f8048cf75b75194b3ea84adac425e6268' 
  AND (
    token = 'NDGdkqdMplNDYngQisjUmlZoxW+51YvfyCEnvM5BxCY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034